@echo off
cls

rem %1 = database server name
rem %2 = database name

@echo on

@echo ********************************************************************************
@echo Adding the CaseSiteMapping table...
@echo off
osql -S %1 -b -E -n -d %2 -i "..\Table Creation\CaseSiteMapping.sql"
@echo on
@echo ********************************************************************************

@echo.

@echo ********************************************************************************
@echo Adding the NewSiteID and NewSiteUrl columns to NavigantPortal tables...
@echo off
osql -S %1 -b -E -n -d %2 -i "..\ChangeScripts\AddNewSiteID.sql"
@echo on
@echo ********************************************************************************

@echo.

@echo Creating NavigantPortal Case Site Mapping stored procedures...
@echo off
osql -S %1 -b -E -n -d %2 -i "..\Stored Procedures\CaseSiteMigration.sql"
@echo on

@echo.

@echo off
NavigantPortal_stored_procedures_only.bat %1 %2
@echo on

pause